from django.db import models

# Create your models here.
class HouseInfo(models.Model):
    house_id = models.AutoField(primary_key=True)
    house_openid = models.CharField(max_length=100, blank=True, null=True)
    house_nbr = models.CharField(max_length=255, blank=True, null=True)
    house_electric = models.CharField(unique=True, max_length=255, blank=True, null=True)
    house_electric_price = models.FloatField(blank=True, null=True)
    house_electric_price_last = models.FloatField(blank=True, null=True)
    house_water = models.CharField(unique=True, max_length=255, blank=True, null=True)
    house_water_price = models.FloatField(blank=True, null=True)
    house_water_price_last = models.FloatField(blank=True, null=True)
    house_electric_last = models.FloatField(blank=True, null=True)
    house_water_last = models.FloatField(blank=True, null=True)
    house_electric_valve = models.IntegerField(blank=True, null=True)
    house_water_valve = models.IntegerField(blank=True, null=True)
    house_price = models.FloatField(blank=True, null=True)
    house_area = models.CharField(max_length=255, blank=True, null=True)
    house_date1 = models.CharField(max_length=255, blank=True, null=True)
    house_date2 = models.CharField(max_length=255, blank=True, null=True)
    house_type = models.IntegerField(blank=True, null=True)
    house_mode = models.IntegerField(blank=True, null=True)
    house_start_time = models.CharField(max_length=50, blank=True, null=True)
    house_guest_id = models.IntegerField(blank=True, null=True)
    house_guest_name = models.CharField(max_length=255, blank=True, null=True)
    house_about_id = models.IntegerField(blank=True, null=True)
    house_about_name = models.CharField(max_length=255, blank=True, null=True)
    
    class Meta:
        db_table = 'house_info'